.\" Man page generated from reStructuredText.
.
.TH "GAMMU-SMSD-ODBC" "7" "Oct 03, 2020" "1.42.0" "Gammu"
.SH NAME
gammu-smsd-odbc \- gammu-smsd(1) backend using ODBC abstraction layer to use any supported database as a message storage
.
.nr rst2man-indent-level 0
.
.de1 rstReportMargin
\\$1 \\n[an-margin]
level \\n[rst2man-indent-level]
level margin: \\n[rst2man-indent\\n[rst2man-indent-level]]
-
\\n[rst2man-indent0]
\\n[rst2man-indent1]
\\n[rst2man-indent2]
..
.de1 INDENT
.\" .rstReportMargin pre:
. RS \\$1
. nr rst2man-indent\\n[rst2man-indent-level] \\n[an-margin]
. nr rst2man-indent-level +1
.\" .rstReportMargin post:
..
.de UNINDENT
. RE
.\" indent \\n[an-margin]
.\" old: \\n[rst2man-indent\\n[rst2man-indent-level]]
.nr rst2man-indent-level -1
.\" new: \\n[rst2man-indent\\n[rst2man-indent-level]]
.in \\n[rst2man-indent\\n[rst2man-indent-level]]u
..
.SH DESCRIPTION
.sp
New in version 1.29.92.

.sp
ODBC backend stores all data in any database supported by \fI\%ODBC\fP, which
parameters are defined by configuration (see gammu\-smsdrc for description of
configuration options).
.sp
For tables description see gammu\-smsd\-tables\&.
.sp
This backend is based on gammu\-smsd\-sql\&.
.SH SUPPORTED DRIVERS
.sp
On Microsoft Windows, Gammu uses native ODBC, on other platforms, \fI\%unixODBC\fP
can be used.
.SH LIMITATIONS
.sp
Due to limits of the ODBC interface, Gammu can not reliably detect which SQL
engine it is connected to.
.sp
In most cases this can be solved by setting \fBSQL\fP setting to
correct dialect.
.sp
If that fails, you can also tweak the SQL queries to work in used SQL server,
see SQL Queries for more details. Still you should set
\fBSQL\fP to closest matching SQL dialect.
.SH CONFIGURATION
.sp
Before running gammu\-smsd you need to create necessary tables in the
database. You can use examples given in database specific backends parts of
this manual to do that.
.sp
You specify data source name (DSN) as \fBHost\fP in
gammu\-smsdrc\&. The data source is configured depending on your platform.
.sp
\fBNOTE:\fP
.INDENT 0.0
.INDENT 3.5
Please remember that SMSD might be running in different context than your
user (separate account on Linux or as as service on Windows), so the ODBC
DSN needs to be configured as system wide in this case (system DSN on
Windows or in global configuration on Linux).
.UNINDENT
.UNINDENT
.sp
On Microsoft Windows, you can find instructions on Microsoft website:
\fI\%https://support.microsoft.com/kb/305599\fP
.sp
For unixODBC this is documented in the user manual:
\fI\%http://www.unixodbc.org/doc/UserManual/\fP
.SH CREATING TABLES
.sp
Prior to starting SMSD you have to create tables it will use. Gammu ships SQL
scripts for several databases to do that:
.INDENT 0.0
.IP \(bu 2
mysql\-create
.IP \(bu 2
pgsql\-create
.IP \(bu 2
sqlite\-create
.UNINDENT
.SH EXAMPLE
.sp
Example configuration:
.INDENT 0.0
.INDENT 3.5
.sp
.nf
.ft C
[smsd]
service = sql
driver = odbc
host = dsn_of_your_database
sql = sql_variant_to_use
user = username
password = password
.ft P
.fi
.UNINDENT
.UNINDENT
.sp
\fBSEE ALSO:\fP
.INDENT 0.0
.INDENT 3.5
gammu\-smsdrc
.UNINDENT
.UNINDENT
.SH AUTHOR
Michal Čihař <michal@cihar.com>
.SH COPYRIGHT
2009-2015, Michal Čihař <michal@cihar.com>
.\" Generated by docutils manpage writer.
.
